package com.dyzx.hbb.modules.fcxs.sql;

public class FcxsSqlHelper {


    public static String getOrderNo(String f) {
        if (f != null && !f.isEmpty()) {
            return "(SELECT order_no  FROM fcxs_order WHERE id=" + f + "   LIMIT 1)";
        } else {
            return "";
        }
    }

    public static String byOrderNo(String str) {
        if (str != null && !str.isEmpty()) {
            return "(SELECT id  FROM fcxs_order WHERE order_no LIKE '%" + str + "%'  LIMIT 1)";
        }else {
            return "";
        }
    }


    public static String getClueNo(String f) {
        if (f != null && !f.isEmpty()) {
            return "(SELECT clue_no  FROM fcxs_clue WHERE id=" + f + "   LIMIT 1)";
        } else {
            return "";
        }
    }
}
